|
SQL Server 2017 : Run Transact-SQL(T-SQL)
2018/01/17 |
|
It's possible to manage SQL Server with Transact-SQL (T-SQL).
|
|
| [1] | Click [New Query] on SQL Server Management Studio. |
|
| [2] | Database Engine Query Editor runs. Input T-SQL commands on here. For executing SQL, click [Run] button, then results are displayed. |
|
| [3] |
It's possible to operate on command prompt.
Windows authentication ⇒ sqlcmd -S [Server\Instance] -E SQL Server authentication ⇒ sqlcmd -S [Server\Instance] -U [User] -P [Password] |
|